package com.meiyou.mapper;

import com.meiyou.pojo.MeiyouTour;
import com.meiyou.pojo.MeiyouTourExample;
import com.meiyou.pojo.TourDetails;
import com.meiyou.pojo.vo.TourApplyVo;
import com.meiyou.pojo.vo.TourVo;

import java.util.List;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

public interface MeiyouTourMapper {
	int countByExample(MeiyouTourExample example);

	int deleteByExample(MeiyouTourExample example);

	int deleteByPrimaryKey(Integer tId);

	int insert(MeiyouTour record);

	int insertSelective(MeiyouTour record);

	List<MeiyouTour> selectByExampleWithBLOBs(MeiyouTourExample example);

	List<MeiyouTour> selectByExample(MeiyouTourExample example);
	
	List<TourVo> selTourVo(String tUcount);
	
	List<TourVo> selTourVoTerm(String tUcount,String sex);
	
	List<TourDetails> selTourDetails(int tId);

	MeiyouTour selectByPrimaryKey(Integer tId);

	List<MeiyouTour> selectTour(MeiyouTour meiyouTour);

	List<MeiyouTour> selAllTour(@Param("tUCount") String tUCount);
	
	List<TourVo> selMyTour(String uCount);
	
	List<TourApplyVo> selMyTourApply(String uCount);
	
	MeiyouTour selTourById(Integer tId);
	
	int updAssess(int tAssess,int tId);
	
	List<TourVo> selLyask(int tId);
	
	@Select("SELECT t_assess FROM meiyou_tour WHERE t_id = #{tId}")
	int selTourAssess(int tId);

	int updateByExampleSelective(@Param("record") MeiyouTour record, @Param("example") MeiyouTourExample example);

	int updateByExampleWithBLOBs(@Param("record") MeiyouTour record, @Param("example") MeiyouTourExample example);

	int updateByExample(@Param("record") MeiyouTour record, @Param("example") MeiyouTourExample example);

	int updateByPrimaryKeySelective(MeiyouTour record);

	int updateByPrimaryKeyWithBLOBs(MeiyouTour record);

	int updateByPrimaryKey(MeiyouTour record);
}